﻿CREATE TABLE [dbo].[Schedule] (
    [FlightDetaiId] INT NOT NULL,
    [EmployeeId]    INT NOT NULL,
    CONSTRAINT [PK_Schedule] PRIMARY KEY CLUSTERED ([FlightDetaiId] ASC, [EmployeeId] ASC),
    CONSTRAINT [FK_Schedule_Employee] FOREIGN KEY ([EmployeeId]) REFERENCES [dbo].[Employee] ([Id]),
    CONSTRAINT [FK_Schedule_FlightDetail] FOREIGN KEY ([FlightDetaiId]) REFERENCES [dbo].[FlightDetail] ([Id])
);

